﻿CREATE TABLE Tracks(
      [TrackPersistentHEX] nchar(16) NOT NULL CONSTRAINT Tracks_PK PRIMARY KEY,
      [Name] nvarchar(40) NOT NULL,
      [Artist] nvarchar(200) NULL,
      [Album] nvarchar(200) NULL,
      [Lyrics] nvarchar(4000) NULL,
      [LyricsWebProviderName] nvarchar(20) NULL
)
GO
CREATE TABLE AppInfo(
	[Property] [nvarchar](255) NOT NULL PRIMARY KEY,
	[Value] [nvarchar](255) NULL
) 
GO
INSERT INTO AppInfo ([Property], [Value])
	VALUES ('Version', '1.0.0.0')
GO
CREATE TABLE LastfmArtist(
	[Artist] nvarchar(255) NOT NULL PRIMARY KEY,
	[DateAdded] datetime NOT NULL,
	[URL] nvarchar(200) NULL,
	[ImageLargeURL] nvarchar(400) NULL,
	[Bio] nvarchar(4000) NULL
)